CREATE TABLE Member (
MemberNo VARCHAR(5), NOT NULL,
FirstName CHAR(20), NOT NULL,
Surname CHAR(30), NOT NULL,
DOB date, NOT NULL,
AddressRegionCode VARCHAR(10), NOT NULL,
PhoneNo VARCHAR(15), NOT NULL,
EmailAddress VARCHAR(100), NOT NULL,
CardNo VARCHAR(16), NOT NULL,
CardCVV VARCHAR(3), NOT NULL,
CardExpiryDate date, NOT NULL);